package com.superman.dao;

import com.superman.entity.Car;
import com.superman.entity.Car_Brand_Category;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface ICarDao {
    List<Car_Brand_Category> queryCarAll() throws SQLException, ClassNotFoundException;
    List<Car_Brand_Category> queryCarByCarID(String car_id) throws SQLException, ClassNotFoundException;
    List<Car_Brand_Category> queryCarByCarIdNumber(String car_number) throws SQLException, ClassNotFoundException;

    int userUpdateCarStatus(String car_id, int status, Connection conn) throws SQLException;
    int insertCar(Car car) throws SQLException, ClassNotFoundException;
    int updateCarRent(String car_id, double rent) throws SQLException, ClassNotFoundException;
    int updateCarUseable(String car_id, int useable) throws SQLException, ClassNotFoundException;
}
